Profiling Report

Dataset statistics

Number of variables	16
Number of observations	11065619
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	1065683
Duplicate rows (%)	9.6%
Total size in memory	1.4 GiB
Average record size in memory	136.0 B

Variable types

Numeric	16

Alerts

Dataset has 1065683 (9.6%) duplicate rows	Duplicates
`voltage` is highly overall correlated with `current` and 7 other fields	High correlation
`current` is highly overall correlated with `voltage` and 3 other fields	High correlation
`power` is highly overall correlated with `voltage` and 8 other fields	High correlation
`energy` is highly overall correlated with `workstation_cpu_power` and 3 other fields	High correlation
`power_factor` is highly overall correlated with `workstation_cpu_power` and 2 other fields	High correlation
`workstation_cpu` is highly overall correlated with `voltage` and 8 other fields	High correlation
`workstation_cpu_power` is highly overall correlated with `voltage` and 9 other fields	High correlation
`workstation_cpu_temperature` is highly overall correlated with `voltage` and 9 other fields	High correlation
`workstation_gpu_power` is highly overall correlated with `voltage` and 8 other fields	High correlation
`workstation_gpu_temperature` is highly overall correlated with `power` and 7 other fields	High correlation
`workstation_ram` is highly overall correlated with `voltage` and 8 other fields	High correlation
`workstation_ram_power` is highly overall correlated with `voltage` and 8 other fields	High correlation
`esp32_temperature` has 3061149 (27.7%) zeros	Zeros
`workstation_cpu` has 6764177 (61.1%) zeros	Zeros
`workstation_cpu_power` has 7758484 (70.1%) zeros	Zeros
`workstation_cpu_temperature` has 7758486 (70.1%) zeros	Zeros
`workstation_gpu` has 10793423 (97.5%) zeros	Zeros
`workstation_gpu_power` has 7758486 (70.1%) zeros	Zeros
`workstation_gpu_temperature` has 8065750 (72.9%) zeros	Zeros
`workstation_ram` has 6675954 (60.3%) zeros	Zeros
`workstation_ram_power` has 7758486 (70.1%) zeros	Zeros

Reproduction

Analysis started	2023-07-25 02:23:16.755294
Analysis finished	2023-07-25 02:30:01.342860
Duration	6 minutes and 44.59 seconds
Software version	ydata-profiling vv4.3.2
Download configuration	config.json

weekday
Real number (ℝ)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.1034053

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.8 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	7
Maximum	7
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1.9884778
Coefficient of variation (CV)	0.4845921
Kurtosis	-1.2117191
Mean	4.1034053
Median Absolute Deviation (MAD)	2
Skewness	-0.1130189
Sum	45406720
Variance	3.9540441
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
4	1793610	16.2%
5	1790363	16.2%
6	1659657	15.0%
7	1605471	14.5%
1	1540765	13.9%
2	1483798	13.4%
3	1191955	10.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1540765	13.9%
2	1483798	13.4%
3	1191955	10.8%
4	1793610	16.2%
5	1790363	16.2%
6	1659657	15.0%
7	1605471	14.5%

Value	Count	Frequency (%)
7	1605471	14.5%
6	1659657	15.0%
5	1790363	16.2%
4	1793610	16.2%
3	1191955	10.8%
2	1483798	13.4%
1	1540765	13.9%

voltage
Real number (ℝ)

HIGH CORRELATION

Distinct	43
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	120.02132

Minimum	116.1
Maximum	120.6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.8 MiB

Quantile statistics

Minimum	116.1
5-th percentile	119.6
Q1	120
median	120.1
Q3	120.1
95-th percentile	120.5
Maximum	120.6
Range	4.5
Interquartile range (IQR)	0.1

Descriptive statistics

Standard deviation	0.30542714
Coefficient of variation (CV)	0.0025447739
Kurtosis	16.340703
Mean	120.02132
Median Absolute Deviation (MAD)	0.1
Skewness	-3.4240325
Sum	1.3281102 × 10⁹
Variance	0.093285736
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
120	3497786	31.6%
120.1	3420896	30.9%
120.2	1675175	15.1%
119.9	976188	8.8%
120.5	579419	5.2%
119.6	353741	3.2%
119.8	96220	0.9%
118.3	86795	0.8%
118.9	85433	0.8%
120.4	66245	0.6%
Other values (33)	227721	2.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
116.1	3	< 0.1%
116.2	3	< 0.1%
116.5	1	< 0.1%
116.7	1	< 0.1%
116.8	4	< 0.1%
116.9	5	< 0.1%
117	10	< 0.1%
117.1	4	< 0.1%
117.2	7	< 0.1%
117.3	8	< 0.1%

Value	Count	Frequency (%)
120.6	788	< 0.1%
120.5	579419	5.2%
120.4	66245	0.6%
120.3	15	< 0.1%
120.2	1675175	15.1%
120.1	3420896	30.9%
120	3497786	31.6%
119.9	976188	8.8%
119.8	96220	0.9%
119.7	12005	0.1%

current
Real number (ℝ)

HIGH CORRELATION

Distinct	1092
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.82034394

Minimum	0.02
Maximum	2.1
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.8 MiB

Quantile statistics

Minimum	0.02
5-th percentile	0.13
Q1	0.68
median	0.92
Q3	0.94
95-th percentile	1.057
Maximum	2.1
Range	2.08
Interquartile range (IQR)	0.26

Descriptive statistics

Standard deviation	0.23061584
Coefficient of variation (CV)	0.28112091
Kurtosis	2.1688513
Mean	0.82034394
Median Absolute Deviation (MAD)	0.11
Skewness	-1.421553
Sum	9077613.5
Variance	0.053183665
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.92	1561932	14.1%
0.93	1446578	13.1%
0.62	1101668	10.0%
0.94	813172	7.3%
0.13	640347	5.8%
0.61	639726	5.8%
0.69	411616	3.7%
1.03	292740	2.6%
1.04	275381	2.5%
1.02	257373	2.3%
Other values (1082)	3625086	32.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.02	5995	0.1%
0.09	85	< 0.1%
0.1	2	< 0.1%
0.11	4	< 0.1%
0.12	10	< 0.1%
0.13	640347	5.8%
0.16	3	< 0.1%
0.19	2	< 0.1%
0.21	1	< 0.1%
0.22	2	< 0.1%

Value	Count	Frequency (%)
2.1	4	< 0.1%
2.09	3	< 0.1%
2.08	1	< 0.1%
1.98	1	< 0.1%
1.976	1	< 0.1%
1.957	1	< 0.1%
1.944	1	< 0.1%
1.94	3	< 0.1%
1.93	5	< 0.1%
1.928	2	< 0.1%

power
Real number (ℝ)

HIGH CORRELATION

Distinct	1368
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	87.191899

Minimum	0
Maximum	245.6
Zeros	6074
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	168.8 MiB

Quantile statistics

Minimum	0
5-th percentile	4.9
Q1	76.6
median	95
Q3	98.8
95-th percentile	113.9
Maximum	245.6
Range	245.6
Interquartile range (IQR)	22.2

Descriptive statistics

Standard deviation	25.869717
Coefficient of variation (CV)	0.29669862
Kurtosis	3.4431944
Mean	87.191899
Median Absolute Deviation (MAD)	13.3
Skewness	-1.6896999
Sum	9.6483234 × 10⁸
Variance	669.24224
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.9	402450	3.6%
94.9	355265	3.2%
94.8	351782	3.2%
95	285556	2.6%
94.7	259319	2.3%
4.8	237737	2.1%
66.1	218663	2.0%
95.1	216869	2.0%
66.2	187526	1.7%
66	179935	1.6%
Other values (1358)	8370517	75.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6074	0.1%
0.4	5	< 0.1%
0.8	1	< 0.1%
1.1	1	< 0.1%
1.2	1	< 0.1%
2.2	1	< 0.1%
2.5	2	< 0.1%
2.9	1	< 0.1%
3.8	1	< 0.1%
4.1	2	< 0.1%

Value	Count	Frequency (%)
245.6	1	< 0.1%
245.1	1	< 0.1%
245	2	< 0.1%
244.6	1	< 0.1%
244.5	1	< 0.1%
244.2	1	< 0.1%
243.3	1	< 0.1%
226.6	1	< 0.1%
223.3	1	< 0.1%
221.1	1	< 0.1%

frequency
Real number (ℝ)

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	59.96468

Minimum	59.3
Maximum	60.3
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.8 MiB

Quantile statistics

Minimum	59.3
5-th percentile	59.9
Q1	59.9
median	60
Q3	60
95-th percentile	60
Maximum	60.3
Range	1
Interquartile range (IQR)	0.1

Descriptive statistics

Standard deviation	0.049704949
Coefficient of variation (CV)	0.00082890377
Kurtosis	-0.7624344
Mean	59.96468
Median Absolute Deviation (MAD)	0
Skewness	-0.82633497
Sum	6.635463 × 10⁸
Variance	0.002470582
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
60	7250525	65.5%
59.9	3712301	33.5%
59.8	99556	0.9%
60.1	3170	< 0.1%
59.7	46	< 0.1%
60.2	18	< 0.1%
60.3	1	< 0.1%
59.3	1	< 0.1%
59.4	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
59.3	1	< 0.1%
59.4	1	< 0.1%
59.7	46	< 0.1%
59.8	99556	0.9%
59.9	3712301	33.5%
60	7250525	65.5%
60.1	3170	< 0.1%
60.2	18	< 0.1%
60.3	1	< 0.1%

Value	Count	Frequency (%)
60.3	1	< 0.1%
60.2	18	< 0.1%
60.1	3170	< 0.1%
60	7250525	65.5%
59.9	3712301	33.5%
59.8	99556	0.9%
59.7	46	< 0.1%
59.4	1	< 0.1%
59.3	1	< 0.1%

energy
Real number (ℝ)

HIGH CORRELATION

Distinct	45882
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	122.39697

Minimum	0
Maximum	442.626
Zeros	82
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	168.8 MiB

Quantile statistics

Minimum	0
5-th percentile	6.46
Q1	38.31
median	119.99
Q3	173.52
95-th percentile	276.77
Maximum	442.626
Range	442.626
Interquartile range (IQR)	135.21

Descriptive statistics

Standard deviation	98.100056
Coefficient of variation (CV)	0.80149087
Kurtosis	1.4894105
Mean	122.39697
Median Absolute Deviation (MAD)	72.76
Skewness	1.1365584
Sum	1.3543983 × 10⁹
Variance	9623.6209
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
137.1	7730	0.1%
137.43	7723	0.1%
136.99	7720	0.1%
137.24	7719	0.1%
137.29	7719	0.1%
136.93	7718	0.1%
137.07	7717	0.1%
136.6	7716	0.1%
136.85	7715	0.1%
136.49	7714	0.1%
Other values (45872)	10988428	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	82	< 0.1%
0.02	570	< 0.1%
0.03	687	< 0.1%
0.04	678	< 0.1%
0.05	760	< 0.1%
0.06	704	< 0.1%
0.07	638	< 0.1%
0.08	651	< 0.1%
0.09	759	< 0.1%
0.1	686	< 0.1%

Value	Count	Frequency (%)
442.626	13	< 0.1%
442.625	31	< 0.1%
442.624	25	< 0.1%
442.623	31	< 0.1%
442.622	26	< 0.1%
442.621	29	< 0.1%
442.62	31	< 0.1%
442.619	25	< 0.1%
442.618	30	< 0.1%
442.617	25	< 0.1%

power_factor
Real number (ℝ)

HIGH CORRELATION

Distinct	57
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.86025335

Minimum	0
Maximum	1
Zeros	6074
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	168.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0.32
Q1	0.86
median	0.89
Q3	0.9
95-th percentile	0.97
Maximum	1
Range	1
Interquartile range (IQR)	0.04

Descriptive statistics

Standard deviation	0.13945405
Coefficient of variation (CV)	0.16210811
Kurtosis	10.851852
Mean	0.86025335
Median Absolute Deviation (MAD)	0.03
Skewness	-3.4260506
Sum	9519235.8
Variance	0.019447431
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.86	3253719	29.4%
0.9	2399702	21.7%
0.89	1296058	11.7%
0.94	678932	6.1%
0.32	609354	5.5%
0.97	538312	4.9%
0.85	391609	3.5%
0.95	361836	3.3%
0.87	328359	3.0%
0.91	299376	2.7%
Other values (47)	908362	8.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6074	0.1%
0.03	4	< 0.1%
0.04	1	< 0.1%
0.07	1	< 0.1%
0.09	1	< 0.1%
0.1	1	< 0.1%
0.17	1	< 0.1%
0.19	2	< 0.1%
0.21	1	< 0.1%
0.27	1	< 0.1%

Value	Count	Frequency (%)
1	903	< 0.1%
0.99	303	< 0.1%
0.98	35033	0.3%
0.97	538312	4.9%
0.96	156648	1.4%
0.95	361836	3.3%
0.94	678932	6.1%
0.93	298199	2.7%
0.92	248311	2.2%
0.91	299376	2.7%

esp32_temperature
Real number (ℝ)

ZEROS

Distinct	87
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.100912

Minimum	0
Maximum	53.3333
Zeros	3061149
Zeros (%)	27.7%
Negative	0
Negative (%)	0.0%
Memory size	168.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	31.67
Q3	33.89
95-th percentile	53.3333
Maximum	53.3333
Range	53.3333
Interquartile range (IQR)	33.89

Descriptive statistics

Standard deviation	15.987543
Coefficient of variation (CV)	0.66335841
Kurtosis	-0.83834116
Mean	24.100912
Median Absolute Deviation (MAD)	4.45
Skewness	-0.47949705
Sum	2.6669151 × 10⁸
Variance	255.60153
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3061149	27.7%
33.89	1957975	17.7%
33.33	1318189	11.9%
34.44	669242	6.0%
53.3333	660831	6.0%
26.67	580106	5.2%
27.22	517443	4.7%
32.78	413152	3.7%
26.11	358328	3.2%
32.22	335751	3.0%
Other values (77)	1193453	10.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3061149	27.7%
20.5556	1	< 0.1%
20.56	1	< 0.1%
21.1111	1	< 0.1%
21.6667	2	< 0.1%
21.67	13	< 0.1%
22.22	774	< 0.1%
22.2222	3	< 0.1%
22.78	23626	0.2%
23.33	21378	0.2%

Value	Count	Frequency (%)
53.3333	660831	6.0%
52.7778	51	< 0.1%
52.2222	74	< 0.1%
51.6667	56	< 0.1%
51.1111	55	< 0.1%
50.5556	64	< 0.1%
50	61	< 0.1%
49.4444	42	< 0.1%
48.8889	61	< 0.1%
48.3333	51	< 0.1%

workstation_cpu
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	2696
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.9972231

Minimum	0
Maximum	100
Zeros	6764177
Zeros (%)	61.1%
Negative	0
Negative (%)	0.0%
Memory size	168.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	4.43
95-th percentile	8.85
Maximum	100
Range	100
Interquartile range (IQR)	4.43

Descriptive statistics

Standard deviation	3.3134864
Coefficient of variation (CV)	1.6590467
Kurtosis	8.2015163
Mean	1.9972231
Median Absolute Deviation (MAD)	0
Skewness	2.0132835
Sum	22100510
Variance	10.979192
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6764177	61.1%
0.1	187572	1.7%
0.2	177318	1.6%
0.3	145380	1.3%
4.43	129114	1.2%
4.3	101019	0.9%
0.4	98748	0.9%
4.56	90528	0.8%
4.36	88841	0.8%
4.49	82023	0.7%
Other values (2686)	3200899	28.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6764177	61.1%
0.1	187572	1.7%
0.2	177318	1.6%
0.26	1	< 0.1%
0.3	145380	1.3%
0.4	98748	0.9%
0.5	52733	0.5%
0.6	29489	0.3%
0.7	11675	0.1%
0.8	8304	0.1%

Value	Count	Frequency (%)
100	6	< 0.1%
99.8	5	< 0.1%
99.62	1	< 0.1%
99.09	1	< 0.1%
98.6	4	< 0.1%
97.53	1	< 0.1%
96.74	1	< 0.1%
96.61	1	< 0.1%
96.22	2	< 0.1%
95.44	1	< 0.1%

workstation_cpu_power
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1225
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.360714

Minimum	0
Maximum	46.29
Zeros	7758484
Zeros (%)	70.1%
Negative	0
Negative (%)	0.0%
Memory size	168.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	36.97
95-th percentile	40.43
Maximum	46.29
Range	46.29
Interquartile range (IQR)	36.97

Descriptive statistics

Standard deviation	17.427578
Coefficient of variation (CV)	1.5340214
Kurtosis	-1.1953699
Mean	11.360714
Median Absolute Deviation (MAD)	0
Skewness	0.88883636
Sum	1.2571334 × 10⁸
Variance	303.72049
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7758484	70.1%
37.67	78647	0.7%
37.58	71798	0.6%
37.68	49000	0.4%
37.36	47579	0.4%
38.25	41225	0.4%
37.66	40317	0.4%
37.61	40279	0.4%
37.77	36555	0.3%
37.72	36175	0.3%
Other values (1215)	2865560	25.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7758484	70.1%
33.32	313	< 0.1%
33.33	545	< 0.1%
33.34	358	< 0.1%
33.35	317	< 0.1%
33.36	252	< 0.1%
33.37	211	< 0.1%
33.38	179	< 0.1%
33.39	198	< 0.1%
33.4	198	< 0.1%

Value	Count	Frequency (%)
46.29	4	< 0.1%
46.07	6	< 0.1%
45.97	4	< 0.1%
45.94	4	< 0.1%
45.93	1	< 0.1%
45.91	4	< 0.1%
45.9	4	< 0.1%
45.88	3	< 0.1%
45.87	7	< 0.1%
45.85	4	< 0.1%

workstation_cpu_temperature
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	68
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.6656744

Minimum	0
Maximum	165
Zeros	7758486
Zeros (%)	70.1%
Negative	0
Negative (%)	0.0%
Memory size	168.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	26
95-th percentile	33
Maximum	165
Range	165
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	13.483595
Coefficient of variation (CV)	1.5559776
Kurtosis	-0.78430312
Mean	8.6656744
Median Absolute Deviation (MAD)	0
Skewness	0.99625473
Sum	95891051
Variance	181.80734
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7758486	70.1%
27	751880	6.8%
26	640354	5.8%
28	407809	3.7%
25	268911	2.4%
29	236227	2.1%
30	158598	1.4%
31	119613	1.1%
32	87037	0.8%
36	84514	0.8%
Other values (58)	552190	5.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7758486	70.1%
18	2	< 0.1%
21	65	< 0.1%
22	176	< 0.1%
23	14306	0.1%
24	61615	0.6%
25	268911	2.4%
26	640354	5.8%
27	751880	6.8%
28	407809	3.7%

Value	Count	Frequency (%)
165	1	< 0.1%
98	1	< 0.1%
88	1	< 0.1%
84	1	< 0.1%
83	2	< 0.1%
82	7	< 0.1%
81	2	< 0.1%
80	1	< 0.1%
79	1	< 0.1%
78	11	< 0.1%

workstation_gpu
Real number (ℝ)

ZEROS

Distinct	52
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.035774151

Minimum	0
Maximum	63
Zeros	10793423
Zeros (%)	97.5%
Negative	0
Negative (%)	0.0%
Memory size	168.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	63
Range	63
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.31441047
Coefficient of variation (CV)	8.7887611
Kurtosis	928.91307
Mean	0.035774151
Median Absolute Deviation (MAD)	0
Skewness	19.8574
Sum	395863.13
Variance	0.098853944
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10793423	97.5%
1	179570	1.6%
2	33668	0.3%
3	18130	0.2%
0.01	17904	0.2%
4	7229	0.1%
5	4581	< 0.1%
0.02	2359	< 0.1%
6	2194	< 0.1%
0.03	1987	< 0.1%
Other values (42)	4574	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10793423	97.5%
0.01	17904	0.2%
0.02	2359	< 0.1%
0.03	1987	< 0.1%
0.04	666	< 0.1%
0.05	285	< 0.1%
0.06	142	< 0.1%
0.07	149	< 0.1%
0.08	81	< 0.1%
0.09	48	< 0.1%

Value	Count	Frequency (%)
63	1	< 0.1%
57	1	< 0.1%
40	2	< 0.1%
34	1	< 0.1%
30	4	< 0.1%
29	3	< 0.1%
28	7	< 0.1%
26	7	< 0.1%
25	8	< 0.1%
24	3	< 0.1%

workstation_gpu_power
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.115553

Minimum	0
Maximum	43
Zeros	7758486
Zeros (%)	70.1%
Negative	0
Negative (%)	0.0%
Memory size	168.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	33
95-th percentile	35
Maximum	43
Range	43
Interquartile range (IQR)	33

Descriptive statistics

Standard deviation	15.517828
Coefficient of variation (CV)	1.5340563
Kurtosis	-1.1976624
Mean	10.115553
Median Absolute Deviation (MAD)	0
Skewness	0.88851294
Sum	1.1193485 × 10⁸
Variance	240.80299
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
0	7758486	70.1%
34	1210054	10.9%
35	836395	7.6%
33	523682	4.7%
36	293044	2.6%
32	185113	1.7%
31	81382	0.7%
30	75011	0.7%
29	60348	0.5%
27	27058	0.2%
Other values (8)	15046	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7758486	70.1%
27	27058	0.2%
28	5810	0.1%
29	60348	0.5%
30	75011	0.7%
31	81382	0.7%
32	185113	1.7%
33	523682	4.7%
34	1210054	10.9%
35	836395	7.6%

Value	Count	Frequency (%)
43	14	< 0.1%
42	226	< 0.1%
41	698	< 0.1%
40	478	< 0.1%
39	227	< 0.1%
38	351	< 0.1%
37	7242	0.1%
36	293044	2.6%
35	836395	7.6%
34	1210054	10.9%

workstation_gpu_temperature
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	337
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.8942826

Minimum	0
Maximum	51.04
Zeros	8065750
Zeros (%)	72.9%
Negative	0
Negative (%)	0.0%
Memory size	168.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	14.13
95-th percentile	14.51
Maximum	51.04
Range	51.04
Interquartile range (IQR)	14.13

Descriptive statistics

Standard deviation	6.3977863
Coefficient of variation (CV)	1.6428665
Kurtosis	-0.66022634
Mean	3.8942826
Median Absolute Deviation (MAD)	0
Skewness	1.0621819
Sum	43092648
Variance	40.931669
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8065750	72.9%
14.32	569430	5.1%
14.42	486260	4.4%
14.22	337750	3.1%
14.33	281392	2.5%
14.23	241006	2.2%
14.13	179944	1.6%
14.52	156379	1.4%
14.51	134180	1.2%
14.43	126337	1.1%
Other values (327)	487191	4.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8065750	72.9%
13.08	1	< 0.1%
13.18	1	< 0.1%
13.27	31	< 0.1%
13.28	17	< 0.1%
13.35	1	< 0.1%
13.36	26	< 0.1%
13.37	216	< 0.1%
13.45	37	< 0.1%
13.46	110	< 0.1%

Value	Count	Frequency (%)
51.04	1	< 0.1%
50.66	1	< 0.1%
50.57	1	< 0.1%
50.48	1	< 0.1%
50.38	1	< 0.1%
50.37	2	< 0.1%
50.29	2	< 0.1%
50.22	1	< 0.1%
50.21	3	< 0.1%
50.11	2	< 0.1%

workstation_ram
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	3560
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.779082

Minimum	0
Maximum	55.2
Zeros	6675954
Zeros (%)	60.3%
Negative	0
Negative (%)	0.0%
Memory size	168.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	37.21
95-th percentile	44.11
Maximum	55.2
Range	55.2
Interquartile range (IQR)	37.21

Descriptive statistics

Standard deviation	18.691217
Coefficient of variation (CV)	1.2647075
Kurtosis	-1.5639621
Mean	14.779082
Median Absolute Deviation (MAD)	0
Skewness	0.55196455
Sum	1.635397 × 10⁸
Variance	349.36159
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6675954	60.3%
42.5	25973	0.2%
42.7	22949	0.2%
47.5	21099	0.2%
44.3	20924	0.2%
47.4	20756	0.2%
38.95	20305	0.2%
38.96	20194	0.2%
45.9	20136	0.2%
42.3	20102	0.2%
Other values (3550)	4197227	37.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6675954	60.3%
11.37	1	< 0.1%
11.38	40	< 0.1%
11.39	29	< 0.1%
11.4	161	< 0.1%
11.41	62	< 0.1%
11.42	15	< 0.1%
11.43	56	< 0.1%
11.44	21	< 0.1%
11.45	45	< 0.1%

Value	Count	Frequency (%)
55.2	4	< 0.1%
55.1	10	< 0.1%
55	17	< 0.1%
54.9	21	< 0.1%
54.8	4	< 0.1%
54.7	10	< 0.1%
54.6	8	< 0.1%
54.5	13	< 0.1%
54.3	12	< 0.1%
54.2	14	< 0.1%

workstation_ram_power
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1696
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.4286255

Minimum	0
Maximum	46.41
Zeros	7758486
Zeros (%)	70.1%
Negative	0
Negative (%)	0.0%
Memory size	168.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	5.44
95-th percentile	10.59
Maximum	46.41
Range	46.41
Interquartile range (IQR)	5.44

Descriptive statistics

Standard deviation	4.0146946
Coefficient of variation (CV)	1.6530727
Kurtosis	0.58053689
Mean	2.4286255
Median Absolute Deviation (MAD)	0
Skewness	1.3643011
Sum	26874244
Variance	16.117773
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7758486	70.1%
7.93	5832	0.1%
7.94	5823	0.1%
8.07	5815	0.1%
8.14	5801	0.1%
8.12	5800	0.1%
7.96	5793	0.1%
8.09	5779	0.1%
8.15	5777	0.1%
8.25	5772	0.1%
Other values (1686)	3254941	29.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7758486	70.1%
2.1	1	< 0.1%
2.13	1	< 0.1%
2.14	1	< 0.1%
2.18	3	< 0.1%
2.21	1	< 0.1%
2.24	1	< 0.1%
2.25	1	< 0.1%
2.27	3	< 0.1%
2.28	3	< 0.1%

Value	Count	Frequency (%)
46.41	1	< 0.1%
34.75	1	< 0.1%
27.65	1	< 0.1%
24.87	1	< 0.1%
22.48	1	< 0.1%
22.11	2	< 0.1%
21.94	5	< 0.1%
21.78	1	< 0.1%
21.63	1	< 0.1%
21.59	1	< 0.1%

Auto

Heatmap
Table

	weekday	voltage	current	power	frequency	energy	power_factor	esp32_temperature	workstation_cpu	workstation_cpu_power	workstation_cpu_temperature	workstation_gpu	workstation_gpu_power	workstation_gpu_temperature	workstation_ram	workstation_ram_power
weekday	1.000	0.048	-0.045	-0.043	-0.001	-0.024	0.025	0.115	-0.007	-0.017	-0.016	-0.005	0.009	-0.027	-0.031	-0.013
voltage	0.048	1.000	-0.821	-0.842	0.121	0.008	-0.188	0.152	-0.606	-0.549	-0.547	-0.133	-0.557	-0.458	-0.567	-0.557
current	-0.045	-0.821	1.000	0.962	-0.006	-0.045	-0.028	-0.298	0.572	0.476	0.480	0.092	0.491	0.453	0.598	0.473
power	-0.043	-0.842	0.962	1.000	-0.003	0.008	0.110	-0.226	0.625	0.540	0.545	0.128	0.549	0.516	0.616	0.537
frequency	-0.001	0.121	-0.006	-0.003	1.000	0.018	0.008	0.014	0.006	0.002	0.001	0.005	0.001	0.008	0.011	-0.002
energy	-0.024	0.008	-0.045	0.008	0.018	1.000	0.464	0.394	0.441	0.540	0.530	0.090	0.545	0.607	0.449	0.491
power_factor	0.025	-0.188	-0.028	0.110	0.008	0.464	1.000	0.372	0.436	0.509	0.521	0.136	0.496	0.457	0.262	0.529
esp32_temperature	0.115	0.152	-0.298	-0.226	0.014	0.394	0.372	1.000	0.227	0.134	0.101	0.159	0.134	0.012	0.220	0.109
workstation_cpu	-0.007	-0.606	0.572	0.625	0.006	0.441	0.436	0.227	1.000	0.897	0.902	0.264	0.887	0.833	0.886	0.892
workstation_cpu_power	-0.017	-0.549	0.476	0.540	0.002	0.540	0.509	0.134	0.897	1.000	0.982	0.277	0.983	0.938	0.726	0.966
workstation_cpu_temperature	-0.016	-0.547	0.480	0.545	0.001	0.530	0.521	0.101	0.902	0.982	1.000	0.245	0.971	0.937	0.713	0.989
workstation_gpu	-0.005	-0.133	0.092	0.128	0.005	0.090	0.136	0.159	0.264	0.277	0.245	1.000	0.259	0.241	0.190	0.214
workstation_gpu_power	0.009	-0.557	0.491	0.549	0.001	0.545	0.496	0.134	0.887	0.983	0.971	0.259	1.000	0.933	0.724	0.960
workstation_gpu_temperature	-0.027	-0.458	0.453	0.516	0.008	0.607	0.457	0.012	0.833	0.938	0.937	0.241	0.933	1.000	0.698	0.902
workstation_ram	-0.031	-0.567	0.598	0.616	0.011	0.449	0.262	0.220	0.886	0.726	0.713	0.190	0.724	0.698	1.000	0.699
workstation_ram_power	-0.013	-0.557	0.473	0.537	-0.002	0.491	0.529	0.109	0.892	0.966	0.989	0.214	0.960	0.902	0.699	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	weekday	voltage	current	power	frequency	energy	power_factor	esp32_temperature	workstation_cpu	workstation_cpu_power	workstation_cpu_temperature	workstation_gpu	workstation_gpu_power	workstation_gpu_temperature	workstation_ram	workstation_ram_power
fecha_servidor
2021-05-05 22:05:27	3	119.9	1.15	126.4	60.0	0.0	0.92	0.0	0.0	0.0	0	0.0	0	0.0	0.0	0.0
2021-05-05 22:05:28	3	119.9	1.15	126.4	60.0	0.0	0.92	0.0	0.0	0.0	0	0.0	0	0.0	0.0	0.0
2021-05-05 22:05:28	3	119.9	1.09	118.5	60.0	0.0	0.91	0.0	0.0	0.0	0	0.0	0	0.0	0.0	0.0
2021-05-05 22:05:29	3	119.9	1.09	118.5	60.0	0.0	0.91	0.0	0.0	0.0	0	0.0	0	0.0	0.0	0.0
2021-05-05 22:05:29	3	120.0	1.01	107.7	60.0	0.0	0.89	0.0	0.0	0.0	0	0.0	0	0.0	0.0	0.0
2021-05-05 22:05:30	3	120.0	1.01	107.7	60.0	0.0	0.89	0.0	0.0	0.0	0	0.0	0	0.0	0.0	0.0
2021-05-05 22:05:30	3	120.0	0.96	100.9	60.0	0.0	0.87	0.0	0.0	0.0	0	0.0	0	0.0	0.0	0.0
2021-05-05 22:05:31	3	120.0	0.96	100.9	60.0	0.0	0.87	0.0	0.0	0.0	0	0.0	0	0.0	0.0	0.0
2021-05-05 22:05:32	3	120.0	1.00	105.4	60.0	0.0	0.88	0.0	0.0	0.0	0	0.0	0	0.0	0.0	0.0
2021-05-05 22:05:33	3	120.0	0.97	101.6	60.0	0.0	0.88	0.0	0.0	0.0	0	0.0	0	0.0	0.0	0.0

	weekday	voltage	current	power	frequency	energy	power_factor	esp32_temperature	workstation_cpu	workstation_cpu_power	workstation_cpu_temperature	workstation_gpu	workstation_gpu_power	workstation_gpu_temperature	workstation_ram	workstation_ram_power
fecha_servidor
2021-12-04 08:18:08	6	118.8	0.701	80.3	59.9	24.850	0.96	53.3333	5.21	34.68	25	0.0	30	0.00	24.95	8.69
2021-12-04 08:18:08	6	119.6	1.047	111.9	59.9	442.626	0.89	53.3333	13.69	38.38	34	0.0	34	14.13	48.56	5.36
2021-12-04 08:18:08	6	119.6	1.031	110.5	59.9	442.626	0.90	53.3333	7.54	38.38	26	0.0	34	14.33	48.55	3.89
2021-12-04 08:18:09	6	118.8	0.707	81.4	59.9	24.850	0.97	53.3333	5.26	34.68	25	0.0	30	0.00	24.95	8.36
2021-12-04 08:18:09	6	119.6	1.152	125.4	60.0	442.626	0.91	53.3333	5.77	38.38	25	0.0	34	14.33	48.55	3.63
2021-12-04 08:18:10	6	118.8	0.712	82.3	59.9	24.850	0.97	53.3333	5.08	34.68	26	0.0	30	0.00	24.95	8.31
2021-12-04 08:18:11	6	118.9	0.675	78.5	59.9	24.850	0.98	53.3333	5.21	34.68	26	0.0	30	0.00	24.94	8.31
2021-12-04 08:18:11	6	119.6	1.189	130.3	59.9	442.626	0.92	53.3333	13.18	38.38	35	0.0	34	14.23	48.58	5.58
2021-12-04 08:18:11	6	119.6	1.152	125.4	59.9	442.626	0.91	53.3333	13.18	38.38	35	0.0	34	14.23	48.58	5.58
2021-12-04 08:18:12	6	118.8	0.691	80.0	59.9	24.850	0.97	53.3333	4.43	34.68	25	0.0	30	0.00	24.95	7.71

Most frequently occurring

	weekday	voltage	current	power	frequency	energy	power_factor	esp32_temperature	# duplicates
895318	6	120.5	0.13	4.9	60.0	136.65	0.32	34.44	3417
1065661	7	120.5	0.13	4.9	60.0	136.77	0.32	34.44	3154
1065656	7	120.5	0.13	4.9	60.0	136.76	0.32	34.44	3138
895306	6	120.5	0.13	4.9	60.0	136.63	0.32	34.44	3107
895299	6	120.5	0.13	4.9	60.0	136.62	0.32	34.44	3077
301182	2	120.5	0.13	4.9	60.0	137.02	0.32	34.44	3028
895323	6	120.5	0.13	4.9	60.0	136.66	0.32	34.44	2991
895313	6	120.5	0.13	4.9	60.0	136.64	0.32	34.44	2725
559503	4	120.5	0.13	4.9	60.0	136.40	0.32	33.89	2704
1065646	7	120.5	0.13	4.9	60.0	136.74	0.32	34.44	2701

Overview

Variables

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring